﻿if exists (select * from sysobjects where name like N'%sp_DMHangHoa_GetAll%')
	drop proc sp_DMHangHoa_GetAll
go
create proc sp_DMHangHoa_GetAll
as
begin
	select MaHangHoa, TenHangHoa, a.MaDonViTinh, DonGia, a.IsUse, IsDelete, 
		a.CreateBy, a.ModifiedBy, a.ModifiedOn, TenDonViTinh
	from DMHangHoa a
		inner join DMDonViTinh b on a.MaDonViTinh = b.MaDonViTinh
	where a.IsUse = 1 and IsDelete = 0
end